<?php

use yii\db\Migration;

class m231104_123105_diandi_mall_order extends Migration
{
    public function up()
    {
        /* 取消外键约束 */
        $this->execute('SET foreign_key_checks = 0');
        
        /* 创建表 */
        $this->createTable('{{%diandi_mall_order}}', [
            'order_id' => "int(11) unsigned NOT NULL AUTO_INCREMENT",
            'order_type' => "int(11) NULL",
            'bloc_id' => "int(11) NULL",
            'store_id' => "int(11) NULL",
            'order_no' => "varchar(20) NOT NULL DEFAULT ''",
            'parent_order_no' => "varchar(20) NULL COMMENT '父级订单编号'",
            'order_body' => "varchar(255) NULL",
            'total_price' => "decimal(10,2) unsigned NOT NULL",
            'pay_price' => "decimal(10,2) unsigned NOT NULL",
            'pay_status' => "tinyint(3) unsigned NOT NULL DEFAULT '10'",
            'pay_time' => "int(11) unsigned NOT NULL DEFAULT '0'",
            'is_split' => "int(11) NULL DEFAULT '0' COMMENT '0:分订单 1总订单'",
            'express_type' => "int(11) NULL DEFAULT '0' COMMENT '配送方式'",
            'express_price' => "decimal(10,2) unsigned NOT NULL",
            'express_company' => "varchar(50) NOT NULL DEFAULT ''",
            'express_no' => "varchar(50) NOT NULL DEFAULT ''",
            'delivery_status' => "tinyint(3) unsigned NOT NULL DEFAULT '0'",
            'delivery_time' => "varchar(20) NOT NULL DEFAULT '0' COMMENT '发货时间'",
            'receipt_status' => "tinyint(3) unsigned NOT NULL DEFAULT '10'",
            'receipt_time' => "int(11) unsigned NOT NULL DEFAULT '0' COMMENT '收货时间'",
            'order_status' => "tinyint(3) unsigned NOT NULL DEFAULT '10'",
            'pay_type' => "int(11) NULL DEFAULT '1' COMMENT '支付按时'",
            'store_codenum' => "varchar(30) NULL COMMENT '提货码'",
            'transaction_id' => "varchar(30) NOT NULL DEFAULT ''",
            'user_id' => "int(11) unsigned NOT NULL DEFAULT '0'",
            'wxapp_id' => "int(11) unsigned NOT NULL DEFAULT '0'",
            'remark' => "varchar(255) NULL",
            'print_id' => "varchar(255) NULL",
            'is_money' => "int(11) NOT NULL DEFAULT '0' COMMENT '资金是否解冻'",
            'is_rebate' => "int(11) NOT NULL DEFAULT '0' COMMENT '是否返利'",
            'create_time' => "int(11) unsigned NOT NULL DEFAULT '0'",
            'update_time' => "int(11) unsigned NOT NULL DEFAULT '0'",
            'PRIMARY KEY (`order_id`)'
        ], "ENGINE=InnoDB  DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC");
        
        /* 索引设置 */
        $this->createIndex('order_no','{{%diandi_mall_order}}','order_no',1);
        
        
        /* 表数据 */
        $this->insert('{{%diandi_mall_order}}',['order_id'=>'1','order_type'=>'1','bloc_id'=>'13','store_id'=>'62','order_no'=>'2022071352975156','parent_order_no'=>NULL,'order_body'=>'商品1','total_price'=>'1.00','pay_price'=>'1.00','pay_status'=>'0','pay_time'=>'0','is_split'=>'0','express_type'=>'0','express_price'=>'0.00','express_company'=>'','express_no'=>'','delivery_status'=>'0','delivery_time'=>'0','receipt_status'=>'10','receipt_time'=>'0','order_status'=>'10','pay_type'=>'1','store_codenum'=>'V2NYw','transaction_id'=>'','user_id'=>'2','wxapp_id'=>'0','remark'=>'','print_id'=>NULL,'is_money'=>'0','is_rebate'=>'0','create_time'=>'1657695844','update_time'=>'1657695844']);
        $this->insert('{{%diandi_mall_order}}',['order_id'=>'2','order_type'=>'1','bloc_id'=>'13','store_id'=>'62','order_no'=>'2022071410156575','parent_order_no'=>NULL,'order_body'=>'商品1','total_price'=>'1.00','pay_price'=>'1.00','pay_status'=>'0','pay_time'=>'0','is_split'=>'0','express_type'=>'0','express_price'=>'0.00','express_company'=>'','express_no'=>'','delivery_status'=>'0','delivery_time'=>'0','receipt_status'=>'10','receipt_time'=>'0','order_status'=>'10','pay_type'=>'1','store_codenum'=>'NQnzQ','transaction_id'=>'','user_id'=>'2','wxapp_id'=>'0','remark'=>'','print_id'=>NULL,'is_money'=>'0','is_rebate'=>'0','create_time'=>'1657778846','update_time'=>'1657778846']);
        $this->insert('{{%diandi_mall_order}}',['order_id'=>'3','order_type'=>'1','bloc_id'=>'13','store_id'=>'62','order_no'=>'2022071452569756','parent_order_no'=>NULL,'order_body'=>'商品1','total_price'=>'1.00','pay_price'=>'1.00','pay_status'=>'0','pay_time'=>'0','is_split'=>'0','express_type'=>'0','express_price'=>'0.00','express_company'=>'','express_no'=>'','delivery_status'=>'0','delivery_time'=>'0','receipt_status'=>'10','receipt_time'=>'0','order_status'=>'10','pay_type'=>'1','store_codenum'=>'KwGvx','transaction_id'=>'','user_id'=>'2','wxapp_id'=>'0','remark'=>'','print_id'=>NULL,'is_money'=>'0','is_rebate'=>'0','create_time'=>'1657784436','update_time'=>'1657784436']);
        $this->insert('{{%diandi_mall_order}}',['order_id'=>'4','order_type'=>'1','bloc_id'=>'13','store_id'=>'62','order_no'=>'2022071599981025','parent_order_no'=>NULL,'order_body'=>'智能门锁','total_price'=>'2.00','pay_price'=>'2.00','pay_status'=>'0','pay_time'=>'0','is_split'=>'0','express_type'=>'0','express_price'=>'0.00','express_company'=>'','express_no'=>'','delivery_status'=>'0','delivery_time'=>'0','receipt_status'=>'10','receipt_time'=>'0','order_status'=>'0','pay_type'=>'1','store_codenum'=>'p2Wk2','transaction_id'=>'','user_id'=>'4','wxapp_id'=>'0','remark'=>'','print_id'=>NULL,'is_money'=>'0','is_rebate'=>'0','create_time'=>'1657838140','update_time'=>'1657838140']);
        $this->insert('{{%diandi_mall_order}}',['order_id'=>'5','order_type'=>'1','bloc_id'=>'13','store_id'=>'62','order_no'=>'2022071949561015','parent_order_no'=>NULL,'order_body'=>'测试商品','total_price'=>'499.00','pay_price'=>'499.00','pay_status'=>'0','pay_time'=>'0','is_split'=>'0','express_type'=>'0','express_price'=>'0.00','express_company'=>'','express_no'=>'','delivery_status'=>'0','delivery_time'=>'0','receipt_status'=>'10','receipt_time'=>'0','order_status'=>'10','pay_type'=>'1','store_codenum'=>'J2B1w','transaction_id'=>'','user_id'=>'10','wxapp_id'=>'0','remark'=>'','print_id'=>NULL,'is_money'=>'0','is_rebate'=>'0','create_time'=>'1658224513','update_time'=>'1658224513']);
        $this->insert('{{%diandi_mall_order}}',['order_id'=>'6','order_type'=>'2','bloc_id'=>'13','store_id'=>'62','order_no'=>'2022072149494856','parent_order_no'=>NULL,'order_body'=>'智能门锁','total_price'=>'513.00','pay_price'=>'513.00','pay_status'=>'1','pay_time'=>'1658802404','is_split'=>'0','express_type'=>'0','express_price'=>'0.00','express_company'=>'1','express_no'=>'','delivery_status'=>'1','delivery_time'=>'1658832366','receipt_status'=>'1','receipt_time'=>'1658832368','order_status'=>'3','pay_type'=>'1','store_codenum'=>'n25dw','transaction_id'=>'','user_id'=>'2','wxapp_id'=>'0','remark'=>'','print_id'=>NULL,'is_money'=>'1','is_rebate'=>'1','create_time'=>'1658389409','update_time'=>'1658389409']);
        $this->insert('{{%diandi_mall_order}}',['order_id'=>'7','order_type'=>'2','bloc_id'=>'13','store_id'=>'62','order_no'=>'2022072197535610','parent_order_no'=>NULL,'order_body'=>'智能门锁','total_price'=>'2.00','pay_price'=>'2.00','pay_status'=>'1','pay_time'=>'1658801184','is_split'=>'0','express_type'=>'0','express_price'=>'0.00','express_company'=>'1','express_no'=>'','delivery_status'=>'1','delivery_time'=>'1658801203','receipt_status'=>'1','receipt_time'=>'1658801519','order_status'=>'4','pay_type'=>'1','store_codenum'=>'DQm42','transaction_id'=>'','user_id'=>'2','wxapp_id'=>'0','remark'=>'','print_id'=>NULL,'is_money'=>'1','is_rebate'=>'1','create_time'=>'1658398650','update_time'=>'1658398650']);
        $this->insert('{{%diandi_mall_order}}',['order_id'=>'8','order_type'=>'2','bloc_id'=>'13','store_id'=>'62','order_no'=>'2022072149485449','parent_order_no'=>NULL,'order_body'=>'智能门锁','total_price'=>'2.00','pay_price'=>'2.00','pay_status'=>'1','pay_time'=>'1658799349','is_split'=>'0','express_type'=>'0','express_price'=>'0.00','express_company'=>'1','express_no'=>'','delivery_status'=>'1','delivery_time'=>'1658799717','receipt_status'=>'1','receipt_time'=>'1658801541','order_status'=>'4','pay_type'=>'1','store_codenum'=>'YwbNw','transaction_id'=>'','user_id'=>'2','wxapp_id'=>'0','remark'=>'','print_id'=>NULL,'is_money'=>'1','is_rebate'=>'1','create_time'=>'1658398689','update_time'=>'1658398689']);
        $this->insert('{{%diandi_mall_order}}',['order_id'=>'9','order_type'=>'2','bloc_id'=>'13','store_id'=>'62','order_no'=>'2022072699571019','parent_order_no'=>NULL,'order_body'=>'店滴云商业授权','total_price'=>'12.00','pay_price'=>'12.00','pay_status'=>'1','pay_time'=>'1658816914','is_split'=>'0','express_type'=>'0','express_price'=>'0.00','express_company'=>'','express_no'=>'','delivery_status'=>'0','delivery_time'=>'0','receipt_status'=>'10','receipt_time'=>'0','order_status'=>'5','pay_type'=>'1','store_codenum'=>'r2v4x','transaction_id'=>'','user_id'=>'2','wxapp_id'=>'0','remark'=>'','print_id'=>NULL,'is_money'=>'0','is_rebate'=>'0','create_time'=>'1658816892','update_time'=>'1658816892']);
        $this->insert('{{%diandi_mall_order}}',['order_id'=>'10','order_type'=>'2','bloc_id'=>'13','store_id'=>'62','order_no'=>'2022072652561011','parent_order_no'=>NULL,'order_body'=>'店滴云商业授权','total_price'=>'12.00','pay_price'=>'12.00','pay_status'=>'1','pay_time'=>'1658817502','is_split'=>'0','express_type'=>'0','express_price'=>'0.00','express_company'=>'','express_no'=>'','delivery_status'=>'0','delivery_time'=>'0','receipt_status'=>'10','receipt_time'=>'0','order_status'=>'5','pay_type'=>'1','store_codenum'=>'n2MXw','transaction_id'=>'','user_id'=>'2','wxapp_id'=>'0','remark'=>'','print_id'=>NULL,'is_money'=>'0','is_rebate'=>'0','create_time'=>'1658817492','update_time'=>'1658817492']);
        $this->insert('{{%diandi_mall_order}}',['order_id'=>'11','order_type'=>'2','bloc_id'=>'13','store_id'=>'62','order_no'=>'2022072649102491','parent_order_no'=>NULL,'order_body'=>'店滴云商业授权','total_price'=>'12.00','pay_price'=>'12.00','pay_status'=>'1','pay_time'=>'1658819648','is_split'=>'0','express_type'=>'0','express_price'=>'0.00','express_company'=>'','express_no'=>'','delivery_status'=>'0','delivery_time'=>'0','receipt_status'=>'10','receipt_time'=>'0','order_status'=>'5','pay_type'=>'1','store_codenum'=>'yxVD2','transaction_id'=>'','user_id'=>'2','wxapp_id'=>'0','remark'=>'','print_id'=>NULL,'is_money'=>'0','is_rebate'=>'0','create_time'=>'1658819633','update_time'=>'1658819633']);
        $this->insert('{{%diandi_mall_order}}',['order_id'=>'12','order_type'=>'1','bloc_id'=>'13','store_id'=>'62','order_no'=>'2022072656535354','parent_order_no'=>NULL,'order_body'=>'店滴云商业授权','total_price'=>'12.00','pay_price'=>'12.00','pay_status'=>'0','pay_time'=>'0','is_split'=>'0','express_type'=>'0','express_price'=>'0.00','express_company'=>'','express_no'=>'','delivery_status'=>'0','delivery_time'=>'0','receipt_status'=>'10','receipt_time'=>'0','order_status'=>'0','pay_type'=>'1','store_codenum'=>'pQlk2','transaction_id'=>'','user_id'=>'4','wxapp_id'=>'0','remark'=>'','print_id'=>NULL,'is_money'=>'0','is_rebate'=>'0','create_time'=>'1658820776','update_time'=>'1658820776']);
        $this->insert('{{%diandi_mall_order}}',['order_id'=>'13','order_type'=>'2','bloc_id'=>'13','store_id'=>'62','order_no'=>'2022072650489910','parent_order_no'=>NULL,'order_body'=>'智能门锁','total_price'=>'1.00','pay_price'=>'1.00','pay_status'=>'1','pay_time'=>'1658824636','is_split'=>'0','express_type'=>'0','express_price'=>'0.00','express_company'=>'','express_no'=>'','delivery_status'=>'0','delivery_time'=>'0','receipt_status'=>'10','receipt_time'=>'0','order_status'=>'10','pay_type'=>'1','store_codenum'=>'n2zyw','transaction_id'=>'','user_id'=>'2','wxapp_id'=>'0','remark'=>'','print_id'=>NULL,'is_money'=>'0','is_rebate'=>'0','create_time'=>'1658824610','update_time'=>'1658824610']);
        $this->insert('{{%diandi_mall_order}}',['order_id'=>'14','order_type'=>'2','bloc_id'=>'13','store_id'=>'62','order_no'=>'2022072651995256','parent_order_no'=>NULL,'order_body'=>'智能门锁','total_price'=>'1.00','pay_price'=>'1.00','pay_status'=>'1','pay_time'=>'1658830624','is_split'=>'0','express_type'=>'0','express_price'=>'0.00','express_company'=>'','express_no'=>'','delivery_status'=>'0','delivery_time'=>'0','receipt_status'=>'10','receipt_time'=>'0','order_status'=>'5','pay_type'=>'1','store_codenum'=>'62qNQ','transaction_id'=>'','user_id'=>'2','wxapp_id'=>'0','remark'=>'','print_id'=>NULL,'is_money'=>'0','is_rebate'=>'0','create_time'=>'1658830611','update_time'=>'1658830611']);
        $this->insert('{{%diandi_mall_order}}',['order_id'=>'15','order_type'=>'2','bloc_id'=>'13','store_id'=>'62','order_no'=>'2022072610254529','parent_order_no'=>NULL,'order_body'=>'智能门锁','total_price'=>'1.00','pay_price'=>'1.00','pay_status'=>'1','pay_time'=>'1658831792','is_split'=>'0','express_type'=>'0','express_price'=>'0.00','express_company'=>'','express_no'=>'','delivery_status'=>'0','delivery_time'=>'0','receipt_status'=>'10','receipt_time'=>'0','order_status'=>'10','pay_type'=>'1','store_codenum'=>'e2dX2','transaction_id'=>'','user_id'=>'2','wxapp_id'=>'0','remark'=>'','print_id'=>NULL,'is_money'=>'0','is_rebate'=>'0','create_time'=>'1658832265','update_time'=>'1658831775']);
        $this->insert('{{%diandi_mall_order}}',['order_id'=>'16','order_type'=>'2','bloc_id'=>'13','store_id'=>'62','order_no'=>'2022072652100975','parent_order_no'=>NULL,'order_body'=>'智能门锁','total_price'=>'1.00','pay_price'=>'1.00','pay_status'=>'1','pay_time'=>'1658832415','is_split'=>'0','express_type'=>'0','express_price'=>'0.00','express_company'=>'','express_no'=>'','delivery_status'=>'0','delivery_time'=>'0','receipt_status'=>'10','receipt_time'=>'0','order_status'=>'0','pay_type'=>'1','store_codenum'=>'0xYg2','transaction_id'=>'','user_id'=>'2','wxapp_id'=>'0','remark'=>'','print_id'=>NULL,'is_money'=>'0','is_rebate'=>'0','create_time'=>'1658832459','update_time'=>'1658832404']);
        $this->insert('{{%diandi_mall_order}}',['order_id'=>'17','order_type'=>'2','bloc_id'=>'13','store_id'=>'62','order_no'=>'2022072610154555','parent_order_no'=>NULL,'order_body'=>'店滴云商业授权','total_price'=>'12.00','pay_price'=>'12.00','pay_status'=>'1','pay_time'=>'1658832809','is_split'=>'0','express_type'=>'0','express_price'=>'0.00','express_company'=>'','express_no'=>'','delivery_status'=>'0','delivery_time'=>'0','receipt_status'=>'10','receipt_time'=>'0','order_status'=>'1','pay_type'=>'1','store_codenum'=>'Zx8Lx','transaction_id'=>'','user_id'=>'2','wxapp_id'=>'0','remark'=>'','print_id'=>NULL,'is_money'=>'0','is_rebate'=>'0','create_time'=>'1658833076','update_time'=>'1658832798']);
        $this->insert('{{%diandi_mall_order}}',['order_id'=>'18','order_type'=>'1','bloc_id'=>'13','store_id'=>'62','order_no'=>'2022072810210053','parent_order_no'=>NULL,'order_body'=>'店滴云商业授权','total_price'=>'12.00','pay_price'=>'12.00','pay_status'=>'1','pay_time'=>'1659007414','is_split'=>'0','express_type'=>'0','express_price'=>'0.00','express_company'=>'','express_no'=>'','delivery_status'=>'0','delivery_time'=>'0','receipt_status'=>'10','receipt_time'=>'0','order_status'=>'1','pay_type'=>'1','store_codenum'=>'zxgY2','transaction_id'=>'4200001433202207289252677809','user_id'=>'4','wxapp_id'=>'0','remark'=>'','print_id'=>NULL,'is_money'=>'0','is_rebate'=>'0','create_time'=>'1659007407','update_time'=>'1659007407']);
        $this->insert('{{%diandi_mall_order}}',['order_id'=>'39','order_type'=>'1','bloc_id'=>'13','store_id'=>'62','order_no'=>'2022073155100995','parent_order_no'=>NULL,'order_body'=>'店滴云品牌代理','total_price'=>'999.00','pay_price'=>'999.00','pay_status'=>'0','pay_time'=>'0','is_split'=>'0','express_type'=>'0','express_price'=>'0.00','express_company'=>'','express_no'=>'','delivery_status'=>'0','delivery_time'=>'0','receipt_status'=>'10','receipt_time'=>'0','order_status'=>'0','pay_type'=>'1','store_codenum'=>'yxjl2','transaction_id'=>'','user_id'=>'4','wxapp_id'=>'0','remark'=>'','print_id'=>NULL,'is_money'=>'0','is_rebate'=>'0','create_time'=>'1659259799','update_time'=>'1659259799']);
        $this->insert('{{%diandi_mall_order}}',['order_id'=>'101','order_type'=>'1','bloc_id'=>'13','store_id'=>'62','order_no'=>'2022073198509797','parent_order_no'=>NULL,'order_body'=>'店滴云商业授权','total_price'=>'4990.00','pay_price'=>'4990.00','pay_status'=>'1','pay_time'=>'1659260475','is_split'=>'0','express_type'=>'0','express_price'=>'0.00','express_company'=>'','express_no'=>'','delivery_status'=>'0','delivery_time'=>'0','receipt_status'=>'10','receipt_time'=>'0','order_status'=>'1','pay_type'=>'1','store_codenum'=>'2NAnw','transaction_id'=>'4200001425202207314873560695','user_id'=>'15','wxapp_id'=>'0','remark'=>'','print_id'=>NULL,'is_money'=>'0','is_rebate'=>'0','create_time'=>'1659260427','update_time'=>'1659260427']);
        $this->insert('{{%diandi_mall_order}}',['order_id'=>'105','order_type'=>'1','bloc_id'=>'13','store_id'=>'62','order_no'=>'2022073156485353','parent_order_no'=>NULL,'order_body'=>'店滴云商业授权','total_price'=>'499.00','pay_price'=>'499.00','pay_status'=>'0','pay_time'=>'0','is_split'=>'0','express_type'=>'0','express_price'=>'0.00','express_company'=>'','express_no'=>'','delivery_status'=>'0','delivery_time'=>'0','receipt_status'=>'10','receipt_time'=>'0','order_status'=>'0','pay_type'=>'1','store_codenum'=>'2B4Mx','transaction_id'=>'','user_id'=>'4','wxapp_id'=>'0','remark'=>'','print_id'=>NULL,'is_money'=>'0','is_rebate'=>'0','create_time'=>'1659277496','update_time'=>'1659277496']);
        $this->insert('{{%diandi_mall_order}}',['order_id'=>'108','order_type'=>'1','bloc_id'=>'13','store_id'=>'62','order_no'=>'2022080357100515','parent_order_no'=>NULL,'order_body'=>'店滴云商业授权','total_price'=>'1996.00','pay_price'=>'1996.00','pay_status'=>'0','pay_time'=>'0','is_split'=>'0','express_type'=>'0','express_price'=>'0.00','express_company'=>'','express_no'=>'','delivery_status'=>'0','delivery_time'=>'0','receipt_status'=>'10','receipt_time'=>'0','order_status'=>'0','pay_type'=>'1','store_codenum'=>'wbKg2','transaction_id'=>'','user_id'=>'4','wxapp_id'=>'0','remark'=>'','print_id'=>NULL,'is_money'=>'0','is_rebate'=>'0','create_time'=>'1659529689','update_time'=>'1659529689']);
        $this->insert('{{%diandi_mall_order}}',['order_id'=>'109','order_type'=>'1','bloc_id'=>'13','store_id'=>'62','order_no'=>'2022080350495354','parent_order_no'=>NULL,'order_body'=>'智能开关','total_price'=>'1596.00','pay_price'=>'1596.00','pay_status'=>'1','pay_time'=>'1659529720','is_split'=>'0','express_type'=>'0','express_price'=>'0.00','express_company'=>'','express_no'=>'','delivery_status'=>'0','delivery_time'=>'0','receipt_status'=>'10','receipt_time'=>'0','order_status'=>'1','pay_type'=>'1','store_codenum'=>'2vEpw','transaction_id'=>'4200001439202208034261602793','user_id'=>'4','wxapp_id'=>'0','remark'=>'','print_id'=>NULL,'is_money'=>'0','is_rebate'=>'0','create_time'=>'1659529714','update_time'=>'1659529714']);
        $this->insert('{{%diandi_mall_order}}',['order_id'=>'152','order_type'=>'1','bloc_id'=>'13','store_id'=>'62','order_no'=>'2022082448974910','parent_order_no'=>NULL,'order_body'=>'智能开关','total_price'=>'399.00','pay_price'=>'399.00','pay_status'=>'0','pay_time'=>'0','is_split'=>'0','express_type'=>'0','express_price'=>'0.00','express_company'=>'','express_no'=>'','delivery_status'=>'0','delivery_time'=>'0','receipt_status'=>'10','receipt_time'=>'0','order_status'=>'0','pay_type'=>'1','store_codenum'=>'wbqgx','transaction_id'=>'','user_id'=>'15','wxapp_id'=>'0','remark'=>'','print_id'=>NULL,'is_money'=>'0','is_rebate'=>'0','create_time'=>'1661356656','update_time'=>'1661356656']);
        $this->insert('{{%diandi_mall_order}}',['order_id'=>'153','order_type'=>'2','bloc_id'=>'13','store_id'=>'62','order_no'=>'2022082410097985','parent_order_no'=>NULL,'order_body'=>'智能开关','total_price'=>'11970.00','pay_price'=>'11970.00','pay_status'=>'1','pay_time'=>'1661356729','is_split'=>'0','express_type'=>'0','express_price'=>'0.00','express_company'=>'','express_no'=>'','delivery_status'=>'0','delivery_time'=>'0','receipt_status'=>'10','receipt_time'=>'0','order_status'=>'1','pay_type'=>'1','store_codenum'=>'2vPpx','transaction_id'=>'4200001596202208248119929223','user_id'=>'15','wxapp_id'=>'0','remark'=>'','print_id'=>NULL,'is_money'=>'0','is_rebate'=>'0','create_time'=>'1661356717','update_time'=>'1661356717']);
        $this->insert('{{%diandi_mall_order}}',['order_id'=>'154','order_type'=>'1','bloc_id'=>'13','store_id'=>'62','order_no'=>'2022092649525651','parent_order_no'=>NULL,'order_body'=>'智能开关','total_price'=>'4788.00','pay_price'=>'4788.00','pay_status'=>'1','pay_time'=>'1664156968','is_split'=>'0','express_type'=>'0','express_price'=>'0.00','express_company'=>'','express_no'=>'','delivery_status'=>'0','delivery_time'=>'0','receipt_status'=>'10','receipt_time'=>'0','order_status'=>'1','pay_type'=>'1','store_codenum'=>'2M6LQ','transaction_id'=>'4200001608202209265278188814','user_id'=>'15','wxapp_id'=>'0','remark'=>'','print_id'=>NULL,'is_money'=>'0','is_rebate'=>'0','create_time'=>'1664156945','update_time'=>'1664156945']);
        $this->insert('{{%diandi_mall_order}}',['order_id'=>'155','order_type'=>'1','bloc_id'=>'13','store_id'=>'62','order_no'=>'2022093050565010','parent_order_no'=>NULL,'order_body'=>'智能开关','total_price'=>'798.00','pay_price'=>'798.00','pay_status'=>'1','pay_time'=>'1664527547','is_split'=>'0','express_type'=>'0','express_price'=>'0.00','express_company'=>'','express_no'=>'','delivery_status'=>'0','delivery_time'=>'0','receipt_status'=>'10','receipt_time'=>'0','order_status'=>'1','pay_type'=>'1','store_codenum'=>'xVY9Q','transaction_id'=>'4200001618202209307593773778','user_id'=>'4','wxapp_id'=>'0','remark'=>'','print_id'=>NULL,'is_money'=>'0','is_rebate'=>'0','create_time'=>'1664527538','update_time'=>'1664527538']);
        $this->insert('{{%diandi_mall_order}}',['order_id'=>'156','order_type'=>'1','bloc_id'=>'13','store_id'=>'62','order_no'=>'2022093052971019','parent_order_no'=>NULL,'order_body'=>'智能开关','total_price'=>'399.00','pay_price'=>'399.00','pay_status'=>'0','pay_time'=>'0','is_split'=>'0','express_type'=>'0','express_price'=>'0.00','express_company'=>'','express_no'=>'','delivery_status'=>'0','delivery_time'=>'0','receipt_status'=>'10','receipt_time'=>'0','order_status'=>'0','pay_type'=>'1','store_codenum'=>'QlPgQ','transaction_id'=>'','user_id'=>'4','wxapp_id'=>'0','remark'=>'','print_id'=>NULL,'is_money'=>'0','is_rebate'=>'0','create_time'=>'1664527588','update_time'=>'1664527588']);
        $this->insert('{{%diandi_mall_order}}',['order_id'=>'157','order_type'=>'1','bloc_id'=>'13','store_id'=>'62','order_no'=>'2022101752974852','parent_order_no'=>NULL,'order_body'=>'智能开关','total_price'=>'399.00','pay_price'=>'399.00','pay_status'=>'0','pay_time'=>'0','is_split'=>'0','express_type'=>'0','express_price'=>'0.00','express_company'=>'','express_no'=>'','delivery_status'=>'0','delivery_time'=>'0','receipt_status'=>'10','receipt_time'=>'0','order_status'=>'0','pay_type'=>'1','store_codenum'=>'2zLZx','transaction_id'=>'','user_id'=>'29','wxapp_id'=>'0','remark'=>'','print_id'=>NULL,'is_money'=>'0','is_rebate'=>'0','create_time'=>'1666010868','update_time'=>'1666010868']);
        
        /* 设置外键约束 */
        $this->execute('SET foreign_key_checks = 1;');
    }

    public function down()
    {
        $this->execute('SET foreign_key_checks = 0');
        /* 删除表 */
        $this->dropTable('{{%diandi_mall_order}}');
        $this->execute('SET foreign_key_checks = 1;');
    }
}

